AmLeadVendorRelationship

Logical Entity Name | AmLeadVendorRelationship
Default Table Name | AmLeadVendorRelationship
Physical Only | NO
Owner | dbo
Definition |
Note |

AmLeadVendorRelationship Columns

ColumnName | Domain | Datatype | NULL | Definition
AmLeadVendorRelationshipID |  | int | NO |
SyOrganizationID |  | int | NO |
ParentSyOrganizationID |  | int | NO |
UserId |  | int | NO |
DateAdded |  | datetime | NO |
TS |  | timestamp | NO |

AmLeadVendorRelationship Primary and Unique Keys

Key Name | Key Type | Keys
PK_AmLeadVendorRelationship_AmLeadVendorRelationshipID | PrimaryKey | AmLeadVendorRelationshipID

AmLeadVendorRelationship Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
SyOrganization | Non-Identifying | One To Zero or More | FK_AmLeadVendorRelationship_ParentSyOrganizationID_SyOrganization_SyOrganizationID |  |  | ParentSyOrganizationID | NO | YES
SyOrganization | Non-Identifying | One To Zero or More | FK_AmLeadVendorRelationship_SyOrganizationID_SyOrganization_SyOrganizationID |  |  | SyOrganizationID | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_AmLeadVendorRelationship_UserId_SyStaff_SyStaffID |  |  | UserId | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

AmLeadVendorRelationship Check Constraints

Check Constraint Name | CheckConstraint

AmLeadVendorRelationship Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

AmLeadVendorRelationship Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.LeadSubVendor | NO |  |  |
Physical (Microsoft SQL Server) dbo.AmLeadVendorRelationship | NO |  |  |

AmLeadVendorRelationship Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Prospect
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Admissions

AmLeadVendorRelationship Data Movement Rules

Name | Type | Rule Text/Value